Telegram Group & Telegram Channel
Дана следующая таблица:

| OrderID | CustomerID | OrderDate | TotalAmount |
|---------|------------|------------|-------------|
| 1 | 1001 | 2022-05-01 | 150.00 |
| 2 | 1002 | 2022-06-15 | 250.00 |
| 3 | 1001 | 2022-07-20 | 100.00 |
| 4 | 1003 | 2022-08-10 | 300.00 |
| 5 | 1002 | 2022-09-05 | 200.00 |

Какой из следующих SQL запросов отберет заказы, сделанные покупателем с ID равным 1001?

A) SELECT * FROM Orders WHERE CustomerID = 1001
B) SELECT * FROM Orders WHERE CustomerID = '1001'
C) SELECT * FROM Orders WHERE CustomerID = '1001' ORDER BY OrderDate DESC
D) SELECT * FROM Orders WHERE CustomerID = 1001 AND TotalAmount > 200.00



tg-me.com/sql_for_qa/122
Create:
Last Update:

Дана следующая таблица:

| OrderID | CustomerID | OrderDate | TotalAmount |
|---------|------------|------------|-------------|
| 1 | 1001 | 2022-05-01 | 150.00 |
| 2 | 1002 | 2022-06-15 | 250.00 |
| 3 | 1001 | 2022-07-20 | 100.00 |
| 4 | 1003 | 2022-08-10 | 300.00 |
| 5 | 1002 | 2022-09-05 | 200.00 |

Какой из следующих SQL запросов отберет заказы, сделанные покупателем с ID равным 1001?

A) SELECT * FROM Orders WHERE CustomerID = 1001
B) SELECT * FROM Orders WHERE CustomerID = '1001'
C) SELECT * FROM Orders WHERE CustomerID = '1001' ORDER BY OrderDate DESC
D) SELECT * FROM Orders WHERE CustomerID = 1001 AND TotalAmount > 200.00

BY SQL для тестировщика


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/122

View MORE
Open in Telegram


SQL для тестировщика Telegram | DID YOU KNOW?

Date: |

Telegram Be The Next Best SPAC

I have no inside knowledge of a potential stock listing of the popular anti-Whatsapp messaging app, Telegram. But I know this much, judging by most people I talk to, especially crypto investors, if Telegram ever went public, people would gobble it up. I know I would. I’m waiting for it. So is Sergei Sergienko, who claims he owns $800,000 of Telegram’s pre-initial coin offering (ICO) tokens. “If Telegram does a SPAC IPO, there would be demand for this issue. It would probably outstrip the interest we saw during the ICO. Why? Because as of right now Telegram looks like a liberal application that can accept anyone - right after WhatsApp and others have turn on the censorship,” he says.

A project of our size needs at least a few hundred million dollars per year to keep going,” Mr. Durov wrote in his public channel on Telegram late last year. “While doing that, we will remain independent and stay true to our values, redefining how a tech company should operate.

SQL для тестировщика from br


Telegram SQL для тестировщика
FROM USA